Profiling Report

Dataset statistics

Number of variables	17
Number of observations	166800
Missing cells	380
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	21.6 MiB
Average record size in memory	136.0 B

Variable types

Numeric	14
Categorical	2
Text	1

Alerts

`City` is highly overall correlated with `County`	High correlation
`Clean Alternative Fuel Vehicle Eligibility` is highly overall correlated with `Electric Range` and 1 other fields	High correlation
`County` is highly overall correlated with `City` and 2 other fields	High correlation
`Electric Range` is highly overall correlated with `Clean Alternative Fuel Vehicle Eligibility` and 2 other fields	High correlation
`Electric Utility` is highly overall correlated with `County` and 1 other fields	High correlation
`Electric Vehicle Type` is highly overall correlated with `Clean Alternative Fuel Vehicle Eligibility` and 1 other fields	High correlation
`Model` is highly overall correlated with `VIN (1-10)`	High correlation
`Model Year` is highly overall correlated with `Electric Range`	High correlation
`Postal Code` is highly overall correlated with `County` and 1 other fields	High correlation
`VIN (1-10)` is highly overall correlated with `Model`	High correlation
`State` is highly skewed (γ1 = -27.32094877)	Skewed
`Postal Code` is highly skewed (γ1 = -30.09608692)	Skewed
`2020 Census Tract` is highly skewed (γ1 = -26.96677648)	Skewed
`DOL Vehicle ID` has unique values	Unique
`Electric Range` has 83517 (50.1%) zeros	Zeros
`Base MSRP` has 163437 (98.0%) zeros	Zeros

Reproduction

Analysis started	2024-02-18 18:43:49.224215
Analysis finished	2024-02-18 18:45:02.077833
Duration	1 minute and 12.85 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

VIN (1-10)
Real number (ℝ)

HIGH CORRELATION

Distinct	260
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	169.79538

Minimum	1
Maximum	1114
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	52
Q3	196
95-th percentile	1029
Maximum	1114
Range	1113
Interquartile range (IQR)	179

Descriptive statistics

Standard deviation	269.25036
Coefficient of variation (CV)	1.5857343
Kurtosis	5.0770067
Mean	169.79538
Median Absolute Deviation (MAD)	43
Skewness	2.4019061
Sum	28321870
Variance	72495.754
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	2904	1.7%
4	2748	1.6%
3	2730	1.6%
5	2690	1.6%
2	2620	1.6%
11	2508	1.5%
10	2500	1.5%
7	2499	1.5%
8	2496	1.5%
12	2496	1.5%
Other values (250)	140609	84.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1969	1.2%
2	2620	1.6%
3	2730	1.6%
4	2748	1.6%
5	2690	1.6%
6	2904	1.7%
7	2499	1.5%
8	2496	1.5%
9	2439	1.5%
10	2500	1.5%

Value	Count	Frequency (%)
1114	1114	0.7%
1090	1090	0.7%
1071	2142	1.3%
1052	1052	0.6%
1041	1041	0.6%
1037	1037	0.6%
1029	1029	0.6%
1022	1022	0.6%
1014	1014	0.6%
993	993	0.6%

County
Real number (ℝ)

HIGH CORRELATION

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49566.95

Minimum	1
Maximum	86594
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	943
Q1	9847
median	86594
Q3	86594
95-th percentile	86594
Maximum	86594
Range	86593
Interquartile range (IQR)	76747

Descriptive statistics

Standard deviation	38769.695
Coefficient of variation (CV)	0.78216826
Kurtosis	-1.9294688
Mean	49566.95
Median Absolute Deviation (MAD)	0
Skewness	-0.12131262
Sum	8.2677672 × 10⁹
Variance	1.5030892 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
86594	86594	51.9%
19570	19570	11.7%
12972	12972	7.8%
9847	9847	5.9%
6042	6042	3.6%
5522	5522	3.3%
4312	4312	2.6%
4039	4039	2.4%
2028	2028	1.2%
1842	1842	1.1%
Other values (39)	14032	8.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	86	0.1%
2	54	< 0.1%
3	27	< 0.1%
4	40	< 0.1%
5	25	< 0.1%
6	24	< 0.1%
7	14	< 0.1%
8	16	< 0.1%
9	18	< 0.1%
10	10	< 0.1%

Value	Count	Frequency (%)
86594	86594	51.9%
19570	19570	11.7%
12972	12972	7.8%
9847	9847	5.9%
6042	6042	3.6%
5522	5522	3.3%
4312	4312	2.6%
4039	4039	2.4%
2028	2028	1.2%
1842	1842	1.1%

City
Real number (ℝ)

HIGH CORRELATION

Distinct	208
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6920.5447

Minimum	1
Maximum	27831
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	140
Q1	859
median	2597
Q3	6032
95-th percentile	27831
Maximum	27831
Range	27830
Interquartile range (IQR)	5173

Descriptive statistics

Standard deviation	9606.3058
Coefficient of variation (CV)	1.3880852
Kurtosis	0.8247084
Mean	6920.5447
Median Absolute Deviation (MAD)	2239
Skewness	1.5953872
Sum	1.1543468 × 10⁹
Variance	92281111
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27831	27831	16.7%
8364	8364	5.0%
6032	6032	3.6%
5869	5869	3.5%
5440	5440	3.3%
5028	5028	3.0%
4876	4876	2.9%
4617	4617	2.8%
4058	4058	2.4%
3510	3510	2.1%
Other values (198)	91175	54.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	227	0.1%
2	150	0.1%
3	90	0.1%
4	88	0.1%
5	85	0.1%
6	60	< 0.1%
7	105	0.1%
8	80	< 0.1%
9	54	< 0.1%
10	60	< 0.1%

Value	Count	Frequency (%)
27831	27831	16.7%
8364	8364	5.0%
6032	6032	3.6%
5869	5869	3.5%
5440	5440	3.3%
5028	5028	3.0%
4876	4876	2.9%
4617	4617	2.8%
4058	4058	2.4%
3510	3510	2.1%

State
Real number (ℝ)

SKEWED

Distinct	44
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.953543

Minimum	0
Maximum	43
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	42
Q1	42
median	42
Q3	42
95-th percentile	42
Maximum	43
Range	43
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.1704863
Coefficient of variation (CV)	0.027899582
Kurtosis	774.16708
Mean	41.953543
Median Absolute Deviation (MAD)	0
Skewness	-27.320949
Sum	6997851
Variance	1.3700382
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	166440	99.8%
7	91	0.1%
41	38	< 0.1%
23	32	< 0.1%
39	24	< 0.1%
27	14	< 0.1%
17	13	< 0.1%
8	12	< 0.1%
12	10	< 0.1%
14	9	< 0.1%
Other values (34)	117	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	5	< 0.1%
3	1	< 0.1%
4	2	< 0.1%
5	7	< 0.1%
6	3	< 0.1%
7	91	0.1%
8	12	< 0.1%
9	7	< 0.1%

Value	Count	Frequency (%)
43	1	< 0.1%
42	166440	99.8%
41	38	< 0.1%
40	3	< 0.1%
39	24	< 0.1%
38	7	< 0.1%
37	1	< 0.1%
36	4	< 0.1%
35	6	< 0.1%
34	1	< 0.1%

Postal Code
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	836
Distinct (%)	0.5%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	98173.714

Minimum	1730
Maximum	99577
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1730
5-th percentile	98006
Q1	98052
median	98122
Q3	98371
95-th percentile	98942
Maximum	99577
Range	97847
Interquartile range (IQR)	319

Descriptive statistics

Standard deviation	2442.5844
Coefficient of variation (CV)	0.024880228
Kurtosis	954.3603
Mean	98173.714
Median Absolute Deviation (MAD)	101
Skewness	-30.096087
Sum	1.6374885 × 10¹⁰
Variance	5966218.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98052	4252	2.5%
98012	3115	1.9%
98033	2840	1.7%
98006	2663	1.6%
98004	2652	1.6%
98115	2553	1.5%
98074	2341	1.4%
98072	2312	1.4%
98188	2286	1.4%
98034	2237	1.3%
Other values (826)	139544	83.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1730	1	< 0.1%
1731	1	< 0.1%
1824	1	< 0.1%
1908	1	< 0.1%
2842	1	< 0.1%
3804	1	< 0.1%
6355	1	< 0.1%
6371	1	< 0.1%
6379	2	< 0.1%
6385	1	< 0.1%

Value	Count	Frequency (%)
99577	1	< 0.1%
99403	57	< 0.1%
99402	9	< 0.1%
99371	1	< 0.1%
99362	329	0.2%
99361	12	< 0.1%
99360	7	< 0.1%
99357	19	< 0.1%
99356	1	< 0.1%
99354	283	0.2%

Model Year
Real number (ℝ)

HIGH CORRELATION

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2020.3418

Minimum	1997
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1997
5-th percentile	2014
Q1	2018
median	2021
Q3	2023
95-th percentile	2023
Maximum	2024
Range	27
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.0014645
Coefficient of variation (CV)	0.0014856222
Kurtosis	0.45101207
Mean	2020.3418
Median Absolute Deviation (MAD)	2
Skewness	-1.086228
Sum	3.3699301 × 10⁸
Variance	9.0087894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
2023	51351	30.8%
2022	27592	16.5%
2021	18774	11.3%
2018	14151	8.5%
2020	11425	6.8%
2019	10860	6.5%
2017	8523	5.1%
2016	5518	3.3%
2015	4833	2.9%
2013	4455	2.7%
Other values (12)	9318	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1997	1	< 0.1%
1998	1	< 0.1%
1999	3	< 0.1%
2000	7	< 0.1%
2002	2	< 0.1%
2003	1	< 0.1%
2008	20	< 0.1%
2010	23	< 0.1%
2011	782	0.5%
2012	1630	1.0%

Value	Count	Frequency (%)
2024	3309	2.0%
2023	51351	30.8%
2022	27592	16.5%
2021	18774	11.3%
2020	11425	6.8%
2019	10860	6.5%
2018	14151	8.5%
2017	8523	5.1%
2016	5518	3.3%
2015	4833	2.9%

Make
Real number (ℝ)

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.009556

Minimum	0
Maximum	38
Zeros	29
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	17
median	33
Q3	33
95-th percentile	36
Maximum	38
Range	38
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.153098
Coefficient of variation (CV)	0.44595344
Kurtosis	-0.82438343
Mean	25.009556
Median Absolute Deviation (MAD)	3
Skewness	-0.87794483
Sum	4171594
Variance	124.39159
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
33	74834	44.9%
27	13848	8.3%
6	13072	7.8%
11	8577	5.1%
4	7196	4.3%
18	6995	4.2%
35	5812	3.5%
36	4717	2.8%
17	4100	2.5%
15	4057	2.4%
Other values (29)	23592	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29	< 0.1%
1	3464	2.1%
2	8	< 0.1%
3	3	< 0.1%
4	7196	4.3%
5	245	0.1%
6	13072	7.8%
7	2878	1.7%
8	28	< 0.1%
9	801	0.5%

Value	Count	Frequency (%)
38	3	< 0.1%
37	3962	2.4%
36	4717	2.8%
35	5812	3.5%
34	5	< 0.1%
33	74834	44.9%
32	788	0.5%
31	275	0.2%
30	3554	2.1%
29	1097	0.7%

Model
Real number (ℝ)

HIGH CORRELATION

Distinct	120
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14115.185

Minimum	1
Maximum	32822
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	360
Q1	1919
median	6413
Q3	28926
95-th percentile	32822
Maximum	32822
Range	32821
Interquartile range (IQR)	27007

Descriptive statistics

Standard deviation	13390.912
Coefficient of variation (CV)	0.94868838
Kurtosis	-1.6560601
Mean	14115.185
Median Absolute Deviation (MAD)	6053
Skewness	0.40752751
Sum	2.3544129 × 10⁹
Variance	1.7931654 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32822	32822	19.7%
28926	28926	17.3%
13274	13274	8.0%
7611	7611	4.6%
6413	6413	3.8%
5429	5429	3.3%
4825	4825	2.9%
3647	3647	2.2%
3161	3161	1.9%
3107	3107	1.9%
Other values (110)	57585	34.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	10	< 0.1%
3	6	< 0.1%
5	10	< 0.1%
6	6	< 0.1%
8	8	< 0.1%
10	30	< 0.1%
11	22	< 0.1%
12	12	< 0.1%
13	26	< 0.1%

Value	Count	Frequency (%)
32822	32822	19.7%
28926	28926	17.3%
13274	13274	8.0%
7611	7611	4.6%
6413	6413	3.8%
5429	5429	3.3%
4825	4825	2.9%
3647	3647	2.2%
3161	3161	1.9%
3107	3107	1.9%

Electric Vehicle Type
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	130293
1	36507

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	166800
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Most occurring characters

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	166800	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	166800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	130293	78.1%
1	36507	21.9%

Clean Alternative Fuel Vehicle Eligibility
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	83517
0	64299
2	18984

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	166800
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	2
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Most occurring characters

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	166800	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	166800	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166800	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	83517	50.1%
0	64299	38.5%
2	18984	11.4%

Electric Range
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	102
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.508993

Minimum	0
Maximum	337
Zeros	83517
Zeros (%)	50.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	84
95-th percentile	259
Maximum	337
Range	337
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	93.271747
Coefficient of variation (CV)	1.516392
Kurtosis	0.38709605
Mean	61.508993
Median Absolute Deviation (MAD)	0
Skewness	1.3743532
Sum	10259700
Variance	8699.6188
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83517	50.1%
215	6272	3.8%
220	4103	2.5%
25	3918	2.3%
84	3918	2.3%
238	3790	2.3%
21	3298	2.0%
32	3182	1.9%
208	2472	1.5%
53	2466	1.5%
Other values (92)	49864	29.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83517	50.1%
6	935	0.6%
8	35	< 0.1%
9	21	< 0.1%
10	162	0.1%
11	3	< 0.1%
12	164	0.1%
13	358	0.2%
14	1109	0.7%
15	89	0.1%

Value	Count	Frequency (%)
337	74	< 0.1%
330	318	0.2%
322	1671	1.0%
308	485	0.3%
293	443	0.3%
291	2335	1.4%
289	646	0.4%
270	275	0.2%
266	1400	0.8%
265	124	0.1%

Base MSRP
Real number (ℝ)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1152.7232

Minimum	0
Maximum	845000
Zeros	163437
Zeros (%)	98.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	845000
Range	845000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8661.0811
Coefficient of variation (CV)	7.5135829
Kurtosis	602.62985
Mean	1152.7232
Median Absolute Deviation (MAD)	0
Skewness	12.846622
Sum	1.9227422 × 10⁸
Variance	75014326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	163437	98.0%
69900	1390	0.8%
31950	381	0.2%
52900	220	0.1%
32250	141	0.1%
54950	130	0.1%
59900	124	0.1%
39995	111	0.1%
36900	100	0.1%
44100	95	0.1%
Other values (21)	671	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	163437	98.0%
31950	381	0.2%
32250	141	0.1%
32995	3	< 0.1%
33950	72	< 0.1%
34995	67	< 0.1%
36800	54	< 0.1%
36900	100	0.1%
39995	111	0.1%
43700	11	< 0.1%

Value	Count	Frequency (%)
845000	1	< 0.1%
184400	10	< 0.1%
110950	20	< 0.1%
109000	6	< 0.1%
102000	15	< 0.1%
98950	20	< 0.1%
91250	5	< 0.1%
90700	20	< 0.1%
89100	7	< 0.1%
81100	22	< 0.1%

Legislative District
Real number (ℝ)

Distinct	49
Distinct (%)	< 0.1%
Missing	360
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	29.178941

Minimum	1
Maximum	49
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	18
median	33
Q3	42
95-th percentile	48
Maximum	49
Range	48
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.853534
Coefficient of variation (CV)	0.50904978
Kurtosis	-1.0877132
Mean	29.178941
Median Absolute Deviation (MAD)	11
Skewness	-0.46529352
Sum	4856543
Variance	220.62746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
41	10837	6.5%
45	10062	6.0%
48	9158	5.5%
1	7231	4.3%
5	7062	4.2%
36	6977	4.2%
11	6607	4.0%
46	6464	3.9%
43	6172	3.7%
37	4933	3.0%
Other values (39)	90937	54.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7231	4.3%
2	1885	1.1%
3	824	0.5%
4	1385	0.8%
5	7062	4.2%
6	1593	1.0%
7	787	0.5%
8	1726	1.0%
9	930	0.6%
10	2879	1.7%

Value	Count	Frequency (%)
49	2250	1.3%
48	9158	5.5%
47	3032	1.8%
46	6464	3.9%
45	10062	6.0%
44	4337	2.6%
43	6172	3.7%
42	2315	1.4%
41	10837	6.5%
40	3637	2.2%

DOL Vehicle ID
Real number (ℝ)

UNIQUE

Distinct	166800
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1724199 × 10⁸

Minimum	4385
Maximum	4.7925477 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	4385
5-th percentile	1.0927191 × 10⁸
Q1	1.7907406 × 10⁸
median	2.2440453 × 10⁸
Q3	2.5134213 × 10⁸
95-th percentile	3.4421029 × 10⁸
Maximum	4.7925477 × 10⁸
Range	4.7925039 × 10⁸
Interquartile range (IQR)	72268068

Descriptive statistics

Standard deviation	77274578
Coefficient of variation (CV)	0.35570737
Kurtosis	3.4968468
Mean	2.1724199 × 10⁸
Median Absolute Deviation (MAD)	30844772
Skewness	0.7260005
Sum	3.6235965 × 10¹³
Variance	5.9713604 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1593721	1	< 0.1%
166073470	1	< 0.1%
148905543	1	< 0.1%
249787583	1	< 0.1%
220480571	1	< 0.1%
249691865	1	< 0.1%
131525467	1	< 0.1%
233740279	1	< 0.1%
144426796	1	< 0.1%
118183838	1	< 0.1%
Other values (166790)	166790	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4385	1	< 0.1%
4777	1	< 0.1%
10286	1	< 0.1%
10734	1	< 0.1%
12050	1	< 0.1%
23145	1	< 0.1%
24629	1	< 0.1%
27702	1	< 0.1%
35325	1	< 0.1%
46112	1	< 0.1%

Value	Count	Frequency (%)
479254772	1	< 0.1%
479114996	1	< 0.1%
478935460	1	< 0.1%
478934571	1	< 0.1%
478926346	1	< 0.1%
478925947	1	< 0.1%
478925163	1	< 0.1%
478924358	1	< 0.1%
478916028	1	< 0.1%
478910428	1	< 0.1%

Vehicle Location
Text

Distinct	835
Distinct (%)	0.5%
Missing	10
Missing (%)	< 0.1%
Memory size	1.3 MiB

Length

Max length	33
Median length	32
Mean length	28.439799
Min length	24

Characters and Unicode

Total characters	4743474
Distinct characters	20
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	286 ?
Unique (%)	0.2%

Sample

1st row	POINT (-120.524012 46.5973939)
2nd row	POINT (-122.817545 46.98876)
3rd row	POINT (-122.1298876 47.4451257)
4th row	POINT (-122.1873 47.820245)
5th row	POINT (-122.2012521 47.3931814)

Value	Count	Frequency (%)
point	166790	33.3%
47.67668	4252	0.8%
122.12302	4252	0.8%
122.1873	3115	0.6%
47.820245	3115	0.6%
122.20264	2840	0.6%
47.6785	2840	0.6%
122.16937	2663	0.5%
47.571015	2663	0.5%
122.201905	2652	0.5%
Other values (1660)	305188	61.0%

Most occurring characters

Value	Count	Frequency (%)
2	492336	10.4%
1	377714	8.0%
4	335804	7.1%
.	333580	7.0%
	333580	7.0%
7	314789	6.6%
5	301633	6.4%
3	203552	4.3%
6	202005	4.3%
8	197371	4.2%
Other values (10)	1651110	34.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2741994	57.8%
Uppercase Letter	833950	17.6%
Other Punctuation	333580	7.0%
Space Separator	333580	7.0%
Dash Punctuation	166790	3.5%
Open Punctuation	166790	3.5%
Close Punctuation	166790	3.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	492336	18.0%
1	377714	13.8%
4	335804	12.2%
7	314789	11.5%
5	301633	11.0%
3	203552	7.4%
6	202005	7.4%
8	197371	7.2%
9	172064	6.3%
0	144726	5.3%

Uppercase Letter

Value	Count	Frequency (%)
O	166790	20.0%
T	166790	20.0%
N	166790	20.0%
I	166790	20.0%
P	166790	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	333580	100.0%

Space Separator

Value	Count	Frequency (%)
	333580	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	166790	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	166790	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	166790	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3909524	82.4%
Latin	833950	17.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	492336	12.6%
1	377714	9.7%
4	335804	8.6%
.	333580	8.5%
	333580	8.5%
7	314789	8.1%
5	301633	7.7%
3	203552	5.2%
6	202005	5.2%
8	197371	5.0%
Other values (5)	817160	20.9%

Latin

Value	Count	Frequency (%)
O	166790	20.0%
T	166790	20.0%
N	166790	20.0%
I	166790	20.0%
P	166790	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4743474	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	492336	10.4%
1	377714	8.0%
4	335804	7.1%
.	333580	7.0%
	333580	7.0%
7	314789	6.6%
5	301633	6.4%
3	203552	4.3%
6	202005	4.3%
8	197371	4.2%
Other values (10)	1651110	34.8%

Electric Utility
Real number (ℝ)

HIGH CORRELATION

Distinct	65
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35695.909

Minimum	1
Maximum	61337
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	674
Q1	9615
median	33669
Q3	61337
95-th percentile	61337
Maximum	61337
Range	61336
Interquartile range (IQR)	51722

Descriptive statistics

Standard deviation	22401.924
Coefficient of variation (CV)	0.6275768
Kurtosis	-1.312451
Mean	35695.909
Median Absolute Deviation (MAD)	27668
Skewness	-0.17697044
Sum	5.9540776 × 10⁹
Variance	5.018462 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
61337	61337	36.8%
33669	33669	20.2%
29600	29600	17.7%
9615	9615	5.8%
7387	7387	4.4%
3805	3805	2.3%
2621	2621	1.6%
1449	1449	0.9%
1245	1245	0.7%
1177	1177	0.7%
Other values (55)	14895	8.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	< 0.1%
2	6	< 0.1%
3	3	< 0.1%
4	4	< 0.1%
5	15	< 0.1%
6	6	< 0.1%
15	45	< 0.1%
16	16	< 0.1%
18	18	< 0.1%
21	21	< 0.1%

Value	Count	Frequency (%)
61337	61337	36.8%
33669	33669	20.2%
29600	29600	17.7%
9615	9615	5.8%
7387	7387	4.4%
3805	3805	2.3%
2621	2621	1.6%
1449	1449	0.9%
1245	1245	0.7%
1177	1177	0.7%

2020 Census Tract
Real number (ℝ)

SKEWED

Distinct	2088
Distinct (%)	1.3%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5.2977092 × 10¹⁰

Minimum	1.0010201 × 10⁹
Maximum	5.6033 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1.0010201 × 10⁹
5-th percentile	5.3011041 × 10¹⁰
Q1	5.303301 × 10¹⁰
median	5.303303 × 10¹⁰
Q3	5.3053073 × 10¹⁰
95-th percentile	5.3067012 × 10¹⁰
Maximum	5.6033 × 10¹⁰
Range	5.503198 × 10¹⁰
Interquartile range (IQR)	20063300

Descriptive statistics

Standard deviation	1.5697544 × 10⁹
Coefficient of variation (CV)	0.029630815
Kurtosis	751.92796
Mean	5.2977092 × 10¹⁰
Median Absolute Deviation (MAD)	27702
Skewness	-26.966776
Sum	8.836314 × 10¹⁵
Variance	2.4641288 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.30330282 × 10¹⁰	1914	1.1%
5.30330285 × 10¹⁰	1001	0.6%
5.303303232 × 10¹⁰	763	0.5%
5.30330262 × 10¹⁰	713	0.4%
5.30330093 × 10¹⁰	647	0.4%
5.30670112 × 10¹⁰	624	0.4%
5.303303232 × 10¹⁰	564	0.3%
5.303303222 × 10¹⁰	545	0.3%
5.303302501 × 10¹⁰	532	0.3%
5.306105211 × 10¹⁰	529	0.3%
Other values (2078)	158963	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001020100	2	< 0.1%
1081041901	1	< 0.1%
1097006803	1	< 0.1%
1117030352	1	< 0.1%
2020000206	1	< 0.1%
4013115900	1	< 0.1%
4013216901	1	< 0.1%
4013610301	1	< 0.1%
4013610302	1	< 0.1%
4013610500	1	< 0.1%

Value	Count	Frequency (%)
5.60330001 × 10¹⁰	1	< 0.1%
5.307794001 × 10¹⁰	5	< 0.1%
5.307794001 × 10¹⁰	3	< 0.1%
5.307794 × 10¹⁰	2	< 0.1%
5.307794 × 10¹⁰	7	< 0.1%
5.307794 × 10¹⁰	7	< 0.1%
5.307794 × 10¹⁰	3	< 0.1%
5.30770034 × 10¹⁰	33	< 0.1%
5.30770032 × 10¹⁰	40	< 0.1%
5.30770031 × 10¹⁰	20	< 0.1%

Auto

Heatmap
Table

	2020 Census Tract	Base MSRP	City	Clean Alternative Fuel Vehicle Eligibility	County	DOL Vehicle ID	Electric Range	Electric Utility	Electric Vehicle Type	Legislative District	Make	Model	Model Year	Postal Code	State	VIN (1-10)
2020 Census Tract	1.000	0.000	-0.365	0.009	-0.312	0.011	-0.015	0.089	0.013	-0.187	-0.016	0.016	0.011	0.058	0.080	0.009
Base MSRP	0.000	1.000	-0.005	0.024	-0.002	-0.035	0.116	-0.003	0.022	0.011	0.003	-0.109	-0.190	-0.003	-0.005	-0.158
City	-0.365	-0.005	1.000	0.044	0.608	-0.000	-0.020	0.159	0.065	0.394	0.051	0.041	0.028	-0.386	0.079	0.045
Clean Alternative Fuel Vehicle Eligibility	0.009	0.024	0.044	1.000	0.013	0.092	-0.717	0.026	0.743	-0.018	0.067	-0.082	0.455	-0.005	0.000	-0.001
County	-0.312	-0.002	0.608	0.013	1.000	0.013	-0.052	0.636	0.099	0.435	0.066	0.075	0.074	-0.746	0.085	0.084
DOL Vehicle ID	0.011	-0.035	-0.000	0.092	0.013	1.000	-0.160	0.028	0.078	-0.017	-0.008	-0.060	0.348	-0.006	0.012	0.069
Electric Range	-0.015	0.116	-0.020	-0.717	-0.052	-0.160	1.000	-0.066	0.525	-0.004	-0.113	-0.127	-0.697	0.055	-0.007	-0.195
Electric Utility	0.089	-0.003	0.159	0.026	0.636	0.028	-0.066	1.000	0.089	0.258	0.058	0.090	0.093	-0.703	0.078	0.095
Electric Vehicle Type	0.013	0.022	0.065	0.743	0.099	0.078	0.525	0.089	1.000	-0.068	-0.296	-0.489	-0.159	0.109	-0.014	-0.445
Legislative District	-0.187	0.011	0.394	-0.018	0.435	-0.017	-0.004	0.258	-0.068	1.000	0.048	0.036	-0.014	-0.338	NaN	0.031
Make	-0.016	0.003	0.051	0.067	0.066	-0.008	-0.113	0.058	-0.296	0.048	1.000	0.494	0.092	-0.091	-0.007	0.424
Model	0.016	-0.109	0.041	-0.082	0.075	-0.060	-0.127	0.090	-0.489	0.036	0.494	1.000	0.064	-0.109	0.002	0.822
Model Year	0.011	-0.190	0.028	0.455	0.074	0.348	-0.697	0.093	-0.159	-0.014	0.092	0.064	1.000	-0.061	0.016	0.180
Postal Code	0.058	-0.003	-0.386	-0.005	-0.746	-0.006	0.055	-0.703	0.109	-0.338	-0.091	-0.109	-0.061	1.000	0.079	-0.105
State	0.080	-0.005	0.079	0.000	0.085	0.012	-0.007	0.078	-0.014	NaN	-0.007	0.002	0.016	0.079	1.000	0.007
VIN (1-10)	0.009	-0.158	0.045	-0.001	0.084	0.069	-0.195	0.095	-0.445	0.031	0.424	0.822	0.180	-0.105	0.007	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	VIN (1-10)	County	City	State	Postal Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle Eligibility	Electric Range	Legislative District	DOL Vehicle ID	Vehicle Location	Electric Utility	2020 Census Tract
0	8	943	639	42	98902.0	2014	9	801	0	0	87	14.0	1593721	POINT (-120.524012 46.5973939)	1245	5.307700e+10
1	4	6042	4058	42	98513.0	2017	33	5429	0	0	200	2.0	257167501	POINT (-122.817545 46.98876)	33669	5.306701e+10
2	5	86594	4617	42	98058.0	2023	4	431	1	2	20	11.0	224071816	POINT (-122.1298876 47.4451257)	61337	5.303303e+10
3	98	19570	5440	42	98012.0	2023	30	1622	0	1	0	21.0	260084653	POINT (-122.1873 47.820245)	33669	5.306105e+10
4	170	86594	2602	42	98031.0	2020	33	28926	0	0	322	33.0	253771913	POINT (-122.2012521 47.3931814)	61337	5.303303e+10
5	35	5522	655	42	98370.0	2024	4	2301	1	0	39	23.0	259427829	POINT (-122.64177 47.737525)	33669	5.303594e+10
6	11	5522	988	42	98367.0	2018	7	2878	1	0	33	26.0	477087012	POINT (-122.6847073 47.50524)	33669	5.303509e+10
7	75	5522	655	42	98370.0	2017	6	6413	0	0	238	23.0	214494213	POINT (-122.64177 47.737525)	33669	5.303509e+10
8	231	5522	988	42	98366.0	2018	33	28926	0	0	215	26.0	280785123	POINT (-122.639265 47.5373)	33669	5.303509e+10
9	3	86594	581	42	98019.0	2018	4	1919	0	0	114	45.0	129133343	POINT (-121.9810747 47.7377962)	61337	5.303303e+10

	VIN (1-10)	County	City	State	Postal Code	Model Year	Make	Model	Electric Vehicle Type	Clean Alternative Fuel Vehicle Eligibility	Electric Range	Legislative District	DOL Vehicle ID	Vehicle Location	Electric Utility	2020 Census Tract
166790	3	86594	27831	42	98102.0	2024	15	175	1	0	33	43.0	258782814	POINT (-122.32226 47.64058)	29600	5.303301e+10
166791	18	4039	2782	42	98225.0	2024	17	3161	1	2	21	42.0	261031214	POINT (-122.486115 48.761615)	3805	5.307300e+10
166792	148	1842	664	42	98221.0	2013	27	13274	0	0	75	10.0	259757998	POINT (-122.615305 48.501275)	33669	5.305794e+10
166793	7	86594	5028	42	98033.0	2022	29	608	0	1	0	48.0	199014224	POINT (-122.20264 47.6785)	61337	5.303302e+10
166794	75	597	21	42	98925.0	2022	18	2043	0	1	0	13.0	212130950	POINT (-121.1761632 47.24106)	33669	5.303798e+10
166795	13	4312	2573	42	99223.0	2013	11	1778	1	2	19	6.0	239527123	POINT (-117.369705 47.62637)	2621	5.306300e+10
166796	410	86594	4876	42	98074.0	2021	33	32822	0	1	0	45.0	148715479	POINT (-122.0313266 47.6285782)	61337	5.303303e+10
166797	375	19570	737	42	98275.0	2022	33	32822	0	1	0	21.0	220504406	POINT (-122.299965 47.94171)	33669	5.306104e+10
166798	10	709	28	42	98564.0	2013	6	4825	1	0	38	20.0	156418475	POINT (-122.487535 46.5290135)	324	5.304197e+10
166799	59	12972	1852	42	98332.0	2017	33	7611	0	0	210	26.0	169045789	POINT (-122.589645 47.342345)	7387	5.305307e+10

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample